Conditional Formatting

MS Excel 2013 Conditional Formatting feature enables you to format a range of values so that values outside certain limits, are automatically formatted. Choose Home Tab >> Style group >> Conditional formatting dropdown Various conditional formatting options:

• Highlight Cells Rules: It opens a continuation menu with various options form defining formatting rules that highlight the cells in the cell selection that contain certain values, text, or dates, or that have values greater or less than a particular value, or that fall within a certain ranges of values.
  Suppose you want to found cell with Percentage of marks < 30 and Mark it as red. Choose Range of cell >> Home tab >> Conditional formatting Drop Down>> Highlight Cell Rules >>Less than

• Top/Bottom Rules: It opens a continuation menu with various options for defining formatting rules that highlight the top and bottom values, percentages, and above and below average values in the cell selection.
• Data Bars: It opens a palette with different color data bars that you can apply to the cell selection to indicate their values relative to each other by clicking the data bar thumbnail.
• Color Scales: It opens a palette with different three- and two- colored scales that you can apply to the cell selection to indicate their values relative to each other by clicking the color scale thumbnail.
• Icon Sets: It opens a palette with different sets of icons that you can apply to the cell selection to indicate their values relative to each other by clicking the icon set.